Oracle Console (SQL*Plus) allows you to use a command-line interface. In other words, it provides interactive text-based screen for you to query input and result output from database.
Note: You have to have SQL*Plus executable in order to get this works. If it is not set under the SQL*Plus default path, you are prompted to locate the executable in the pop up.
Downloading
SQL*Plus is included in packages Oracle Client / Oracle Instant Client. You can download it through -
Oracle Client
http://www.oracle.com/technology/software/products/database/index.htmlOracle Instant Client
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
Open Console
To open console
- Open the connection and select Tools -> Console from the main menu or just simply press Cmd-Shift-C.
- Edit your SQL statement in the console command prompt.
Hint: To open a new console window you can also control-click the Connection/Schema node of the navigation pane and select SQL*Plus from the popup menu.
Hint: You are allowed to open multiple console windows which represents different connection each.
Exit Console
To exit console
- Click the cross button at the main bar.
or - Type exit or quit in the console window and press Enter.